Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_14

R_14

Kinship

Kinship

Kin_KinshipID

 

 

R_25

R_25

Person

Person

Per_PersonID

 

 

R_401

R_401

Personnel

MedResource

PersonID

 

 

R_513

R_513

Person

Contractor

PersonID

 

 

R_737

R_737

LimitType

ContractLimit

LimitTypeID

 

 

R_738

R_738

LimitType

LimitTypeText

LimitTypeID

 

 

R_845

R_845

Contract

LContractContract

Con_ContractID

 

 

R_846

R_846

Contract

LContractContract

ContractID

 

 

R_1152

R_1152

Reservation

PerfService

ReservationID

 

 

R_1153

R_1153

Reservation

Reservation

Res_ReservationID

 

 

R_1162

R_1162

Service

Reservation

ServID

 

 

R_1194

R_1194

Service

LServicePriceList

ServID

 

 

R_1195

R_1195

PriceList

LServicePriceList

PriceListID

 

 

R_1196

R_1196

Service

LServiceGroup

ServID

 

 

R_1197

R_1197

ServiceGroup

LServiceGroup

ServiceGroupID

 

 

R_1198

R_1198

ServiceGroup

LBenefitPlanService

ServiceGroupID

 

 

R_1199

R_1199

Service

LBenefitPlanService

ServID

 

 

R_1203

R_1203

BenefitPlan

LBenefitPlanService

BenefitPlanID

 

 

R_1204

R_1204

BenefitPlanGroup

BenefitPlan

BenefitPlanGroupID

 

 

R_1205

R_1205

BenefitPlanGroup

BenefitPlanGroupText

BenefitPlanGroupID

 

 

R_1208

R_1208

BenefitPlan

BenefitPlanContract

BenefitPlanID

 

 

R_1209

R_1209

BPPackageKind

BPPackageKindText

BPPackageKindID

 

 

R_1211

R_1211

BPPackageKind

BenefitPlanContract

BPPackageKindID

 

 

R_1215

R_1215

BenefitPlanContract

LSubBenefitPlanContract

Ben_BenefitPlanContractID

 

 

R_1216

R_1216

BenefitPlanContract

LSubBenefitPlanContract

BenefitPlanContractID

 

 

R_1217

R_1217

InvoiceChangeRule

BenefitPlanContract

InvoiceChangeRuleID

 

 

R_1222

R_1222

BenefitPlanContract

LBenefitPlanContrBeneficiary

BenefitPlanContractID

 

 

R_1223

R_1223

Beneficiary

SubBeneficiary

PersonID

 

 

R_1224

R_1224

Beneficiary

SubBeneficiary

Ben_PersonID

 

 

R_1225

R_1225

Kinship

SubBeneficiary

KinshipID

 

 

R_1226

R_1226

Kinship

SubbeneficiaryData

KinshipID

 

 

R_1227

R_1227

BenefitPlanContract

SubbeneficiaryData

BenefitPlanContractID

 

 

R_1229

R_1229

BeneficiaryStatus

BeneficiaryStatusText

BeneficiaryStatusID

 

 

R_1232

R_1232

Person

Beneficiary

PersonID

 

 

R_1234

R_1234

CardKind

Beneficiary

CardKindID

 

 

R_1235

R_1235

CardKind

CardKindText

CardKindID

 

 

R_1238

R_1238

CardCreationRules

BenefitPlanContract

CardCreationRules

 

 

R_1239

R_1239

Contract

BenefitPlanContract

ContractID

 

 

R_1241

R_1241

ContractLimit

LBenefitPlanContractLimit

ContractLimitID

 

 

R_1242

R_1242

Contractor

Contract

ContractorID

 

 

R_1244

R_1244

PayerGroup

Contractor

PayerGroupID

 

 

R_1245

R_1245

PayerGroup

PayerGroupText

PayerGroupID

 

 

R_1251

R_1251

LimitKind

LimitKindText

LimitKindID

 

 

R_1252

R_1252

LimitKind

ContractLimit

LimitKindID

 

 

R_1253

R_1253

LimitPeriod

LimitPeriodText

LimitPeriodID

 

 

R_1256

R_1256

LimitPeriod

ContractLimit

LimitPeriodID

 

 

R_1257

R_1257

Currency

ContractLimit

CurrencyID

 

 

R_1258

R_1258

ContractLimit

LBenefitPlanServiceLimit

ContractLimitID

 

 

R_1260

R_1260

LBenefitPlanService

LBPServicePriceList

LBenefitPlanServID

 

 

R_1261

R_1261

LBenefitPlanService

LBPServiceInformationAttr

LBenefitPlanServID

 

 


2  3  4